package com.drool.mediaplayer.Database;

import android.provider.BaseColumns;

public class MediaFilesDB{
	private MediaFilesDB(){};
	
	public static final class FileHeader implements BaseColumns{
		private FileHeader() {};
		public static final String HDR_TABLE_NAME = "FileHeaderTab";
		public static final String HDR_FILE_NAME = "Filename";
		public static final String HDR_PATH = "Path";
		public static final String HDR_DISP_NAME = "DisplayName";
		public static final String HDR_DATE_ADDED = "DateAdded";
		public static final String HDR_FILE_ID = "FileId";
		public static final String HDR_FILE_TYPE = "Type";//v = video a= audio
	}
	
	public static final class VideoFiles implements BaseColumns{
		private VideoFiles() {};
		public static final String VIDEO_TABLE_NAME = "VideoFilesTab";
		public static final String VIDEO_ALBUM = "Album";		
		public static final String VIDEO_ARTIST = "Artist";
		public static final String VIDEO_GENRE = "Genre";
		//public static final String VIDEO_ART = "Art";
		public static final String VIDEO_DURATION = "Duration";
		public static final String VIDEO_DESCRIPTION = "Description";
		public static final String VIDEO_LANGUAGE = "Language";
		public static final String VIDEO_NUM_OF_TIMES = "NumOfTimesPlayed";
		
	}
	
	public static final class AudioFiles implements BaseColumns{
		private AudioFiles() {};
		public static final String AUDIO_TABLE_NAME = "AudioFilesTab";
		//public static final String AUDIO_ALBUM = "Album";
		public static final String AUDIO_ALBUM_ID = "AlbumId";
		public static final String AUDIO_ARTIST = "Artist";
		public static final String AUDIO_GENRE = "Genre";
		//public static final String AUDIO_ART = "Art";
		public static final String AUDIO_DURATION = "Duration";
		public static final String AUDIO_TRACK = "Track";
		public static final String AUDIO_YEAR = "Year";
		public static final String AUDIO_NUM_OF_TIMES = "NumOfTimesPlayed";
	}
	
	public static final class Playlist implements BaseColumns{
		private Playlist() {};
		public static final String PLAYLIST_TABLE_NAME = "Playlist";
		public static final String PLAYLIST_NAME = "Name";
		public static final String PLAYLIST_CREATED_ON = "Created_On";
	}
	
	public static final class PlaylistItems implements BaseColumns{
		private PlaylistItems() {};
		
		public static final String PLAYLIST_ITEMS_TABLE_NAME = "Pl_Items";
		public static final String PLAYLIST_ITEMS_PL_ID = "Playlist_Id";
		public static final String PLAYLIST_ITEMS_MEDIA_ID = "MEDIA_Id";
		public static final String PLAYLIST_ITEMS_MEDIA_NAME = "Media_Name";
		public static final String PLAYLIST_ITEMS_MEDIA_TYPE = "Media_Type";
	}
	
}
//TODO Make Sure that all cursrs are close, all DB conns are closed when not required